<?php

//tablename
$opts['tb'] = $PACTS_cfg->bookletfootermessagetablename;

// Name of field which is the unique key
$opts['key'] = 'PageNo';

// Type of key field (int/real/string/date etc.)
$opts['key_type'] = 'int';

// Sorting field(s)
$opts['sort_field'] = array('PageNo');


$opts['fdd']['PageNo'] = array(
  'name'     => 'PageNo',
  'select'   => 'N',
  'maxlen'   => 10,
  'default'  => '',
  'required' => true,
  'sort'     => true,
  'values'   => range(1,999)
);
$opts['fdd']['MessageTextLine1'] = array(
  'name'     => 'MessageTextLine1',
  'select'   => 'T',
  'maxlen'   => 100,
  'width'    => 200,
  'sort'     => true
);
$opts['fdd']['MessageTextLine2'] = array(
  'name'     => 'MessageTextLine2',
  'select'   => 'T',
  'maxlen'   => 100,
  'width'    => 200,
  'sort'     => true
);
$opts['fdd']['MessageTextLine3'] = array(
  'name'     => 'MessageTextLine3',
  'select'   => 'T',
  'maxlen'   => 100,
  'width'    => 200,
  'sort'     => true
);

// Now important call to phpMyEdit
new phpMyEdit($opts);

?>